﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace nplJobsDAL.Select
{
    public class SelectCategoryWithJobSeeker:DataAccessBase
    {
        string procedureName = "spCategoryWithJobSeeker";        

        #region GetJobSeekerCount
            public DataSet GetJobSeekerCountByCategory()
            {
                DataBaseHelper dbHelper;
                DataSet dsJobSeekerCount;

                try
                {                
                    dbHelper = new DataBaseHelper(procedureName);       
                    SqlParameter[] prm = null;
                    dbHelper.Parameters = prm;
                    return dsJobSeekerCount = dbHelper.Run(base.ConnectionString, dbHelper.Parameters);              
                }
                catch (Exception)
                {
                    throw;
                }
            }
        #endregion
    
    }
}
